declare @table as table
(fileid int,
filegroup int ,
totalextents int,
usedextents int ,
name nvarchar(200),
filename nvarchar(200))

insert @table exec('DBCC SHOWFILESTATS')

select @@SERVERNAME as hostname,DB_NAME() as dbname,
fileid ,
filegroup  ,
totalextents ,
usedextents  ,
totalextents *64,
usedextents *64,
name ,
LEFT(filename,2),
filename ,GETDATE() as datetime 
from @table